Tabela MealReceival

Definicja tabeli MealReceival

Name

MealReceival

Code

MealReceival

Comment

Tabela zawiera informacje o ilosciach posilków przyjetych od dostawcy posilków do poszczególnych jednostek placówki.
Jeden rekord odpowiada przyjeciu danej ilosci posilków (Quantity) danego typu (ResourceID) danego dnia (Day) o danej porze (MealTypeID - sniadanie, obiad, kolacja).


Lista kolumn tabeli MealReceival

Name

Code

MealReceivalID

MealReceivalID

MealTypeID

MealTypeID

ResourceID

ResourceID

Day

Day

Quantity

Quantity

Active

Active


Kolumna MealReceivalID tabeli MealReceival

Definicja kolumny MealReceivalID tabeli MealReceival

Name

MealReceivalID

Code

MealReceivalID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MealTypeID tabeli MealReceival

Definicja kolumny MealTypeID tabeli MealReceival

Name

MealTypeID

Code

MealTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli MealReceival

Definicja kolumny ResourceID tabeli MealReceival

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Day tabeli MealReceival

Definicja kolumny Day tabeli MealReceival

Name

Day

Code

Day

Data Type

DATE

Mandatory

Yes

Comment

Dzien przyjecia posilku


Kolumna Quantity tabeli MealReceival

Definicja kolumny Quantity tabeli MealReceival

Name

Quantity

Code

Quantity

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc posilków


Kolumna Active tabeli MealReceival

Definicja kolumny Active tabeli MealReceival

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli MealReceival

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MealReceival

Definicja klucza Identifier_1 tabeli MealReceival

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment